Owner

dbo

Creation Date

10-07-2003 10:31:35

Remarks

Columns

Name	Type	Length	IsNullable	Collation
OrderID	int	4
CustomerID	nchar	10		SQL_Latin1_General_CP1_CI_AS
EmployeeID	int	4
OrderDate	datetime	8
RequiredDate	datetime	8
ShippedDate	datetime	8
ShipVia	int	4
Freight	money	8
ShipName	nvarchar	80		SQL_Latin1_General_CP1_CI_AS
ShipName	sysname	80		SQL_Latin1_General_CP1_CI_AS
ShipAddress	nvarchar	120		SQL_Latin1_General_CP1_CI_AS
ShipAddress	sysname	120		SQL_Latin1_General_CP1_CI_AS
ShipCity	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
ShipCity	sysname	30		SQL_Latin1_General_CP1_CI_AS
ShipRegion	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
ShipRegion	sysname	30		SQL_Latin1_General_CP1_CI_AS
ShipPostalCode	nvarchar	20		SQL_Latin1_General_CP1_CI_AS
ShipPostalCode	sysname	20		SQL_Latin1_General_CP1_CI_AS
ShipCountry	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
ShipCountry	sysname	30		SQL_Latin1_General_CP1_CI_AS
CompanyName	nvarchar	80		SQL_Latin1_General_CP1_CI_AS
CompanyName	sysname	80		SQL_Latin1_General_CP1_CI_AS
Address	nvarchar	120		SQL_Latin1_General_CP1_CI_AS
Address	sysname	120		SQL_Latin1_General_CP1_CI_AS
City	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
City	sysname	30		SQL_Latin1_General_CP1_CI_AS
Region	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
Region	sysname	30		SQL_Latin1_General_CP1_CI_AS
PostalCode	nvarchar	20		SQL_Latin1_General_CP1_CI_AS
PostalCode	sysname	20		SQL_Latin1_General_CP1_CI_AS
Country	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
Country	sysname	30		SQL_Latin1_General_CP1_CI_AS

View Definition

create view "Orders Qry" AS
SELECT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate, 
	Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, 
	Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry, 
	Customers.CompanyName, Customers.Address, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country
FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID